<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_favourable_activity`;");
E_C("CREATE TABLE `ecs_favourable_activity` (
  `act_id` smallint(5) unsigned NOT NULL auto_increment,
  `act_name` varchar(255) NOT NULL,
  `start_time` int(10) unsigned NOT NULL,
  `end_time` int(10) unsigned NOT NULL,
  `user_rank` varchar(255) NOT NULL,
  `act_range` tinyint(3) unsigned NOT NULL,
  `act_range_ext` varchar(255) NOT NULL,
  `min_amount` decimal(10,2) unsigned NOT NULL,
  `max_amount` decimal(10,2) unsigned NOT NULL,
  `act_type` tinyint(3) unsigned NOT NULL,
  `act_type_ext` decimal(10,2) unsigned NOT NULL,
  `gift` text NOT NULL,
  `sort_order` tinyint(3) unsigned NOT NULL default '50',
  PRIMARY KEY  (`act_id`),
  KEY `act_name` (`act_name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_favourable_activity` values('4','新春优惠','1420358400','1483862400','0,1,2,3','3','236,237,241,246,251,253','20.00','500.00','2','70.00','a:0:{}','50');");
E_D("replace into `ecs_favourable_activity` values('3','优惠猪肉','1419840000','1483344000','0,1,2,3','0','','10.00','3000.00','0','50.00','a:3:{i:0;a:3:{s:2:\"id\";s:3:\"236\";s:4:\"name\";s:19:\"百利 甜酒 700ml\";s:5:\"price\";s:1:\"5\";}i:1;a:3:{s:2:\"id\";s:3:\"241\";s:4:\"name\";s:29:\"厄瓜多尔白虾40/50 2000g\";s:5:\"price\";s:1:\"5\";}i:2;a:3:{s:2:\"id\";s:3:\"250\";s:4:\"name\";s:30:\"精选 ZESPRI 奇异绿果6粒\";s:5:\"price\";s:1:\"5\";}}','50');");

require("../../inc/footer.php");
?>